
IF OBJECT_ID('dbo.UserBuddy', 'U') IS NOT NULL
  DROP TABLE dbo.UserBuddy
GO

CREATE TABLE dbo.UserBuddy
(
	BuddyId int identity(1,1) NOT NULL, 
	User1Id uniqueidentifier foreign key references aspnet_Users(UserId) NOT NULL, 
	User2Id uniqueidentifier foreign key references aspnet_Users(UserId) NOT NULL, 
    CONSTRAINT PK_UserBuddy PRIMARY KEY (BuddyId)
)
GO
